Go to Financial ? Setup ? General ? Currencies, and then click Import: XRate.
On this page, you can import the daily exchange rates against the default currency in the CSV format and view the import results.
To create the daily exchange rates CSV file in Microsoft Excel, you should follow the format as shown in the following:
The first column displays the targeted currency codes, the second column displays the currency description, and the third column displays the exchange rates of the targeted currencies against the default currency on a particular day.
To import the daily exchange rates, function rights 391 – XML Upload: Currency exchange rate and 500 – XML Upload: Currency are required. By default, users with the General manager, Controller, XML Administrator, and XML User roles have these function rights.
Note:
The information in this document is applicable to product update 257 and higher. If you have versions lower than this, certain features explained here will not be applicable.
This field displays the default currency which the exchange rates are against. You cannot change the default currency. You can click the currency link to open the settings screen for the currency. This default currency is the currency you have selected when you define the financial settings. For more information, see Defining financial settings.
This field displays the exchange rate type that can be imported, which are Daily and Period. By default, the Daily exchange rate type is selected.
Type or select the exchange rate date. By default, it will display the current date.
Click Browse to search for the exchange rates CSV file which you want to import.
Click this button to import the selected CSV file that contains the daily exchange rates of various currencies against the default currency. The system will validate the file before the import process starts. If the file is not in the CSV format, the message “Invalid file” will be displayed after you have clicked this button.
Click this to exit.